package com.shzu.jwc.ty.dao;

import com.shzu.jwc.ty.bean.PeExaminationAppointment;
import com.shzu.jwc.ty.bean.PeExaminationAppointmentExample;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface PeExaminationAppointmentMapper {
    long countByExample(PeExaminationAppointmentExample example);

    int deleteByExample(PeExaminationAppointmentExample example);

    int deleteByPrimaryKey(Integer peExaminationAppointmentId);

    int insert(PeExaminationAppointment record);

    int insertSelective(PeExaminationAppointment record);

    List<PeExaminationAppointment> selectByExample(PeExaminationAppointmentExample example);

    PeExaminationAppointment selectByPrimaryKey(Integer peExaminationAppointmentId);

    int updateByExampleSelective(@Param("record") PeExaminationAppointment record, @Param("example") PeExaminationAppointmentExample example);

    int updateByExample(@Param("record") PeExaminationAppointment record, @Param("example") PeExaminationAppointmentExample example);

    int updateByPrimaryKeySelective(PeExaminationAppointment record);

    int updateByPrimaryKey(PeExaminationAppointment record);

    List<PeExaminationAppointment> getpeExaminationscore(@Param("systemYearId")Integer systemYearId,@Param("systenSelectcourseCode")String systenSelectcourseCode,@Param("startPos") Integer startPos,@Param("pageSize") Integer pageSize);

    long countpeExaminationscore(@Param("systemYearId")Integer systemYearId,@Param("systenSelectcourseCode")String systenSelectcourseCode);

    List<PeExaminationAppointment> selectpeExaminationscore(@Param("systemYearId")Integer systemYearId,@Param("systenSelectcourseCode")String systenSelectcourseCode,@Param("peExaminationId") Integer peExaminationId,@Param("startPos") Integer startPos,@Param("pageSize") Integer pageSize);

    List<PeExaminationAppointment> upselectpeExaminationscore(@Param("systemYearId")Integer systemYearId,@Param("systenSelectcourseCode")String systenSelectcourseCode,@Param("userStudentInfoYear") Integer userStudentInfoYear,@Param("userStudentInfoCollege") String userStudentInfoCollege,@Param("peExaminationId") Integer peExaminationId);

    long countselectpeExamination(@Param("systemYearId")Integer systemYearId,@Param("systenSelectcourseCode")String systenSelectcourseCode,@Param("peExaminationId") Integer peExaminationId);

    Integer updatestatusbyexamination(@Param("peExaminationAppointmentState") Integer peExaminationAppointmentState,@Param("peExaminationId") Integer peExaminationId);

    Integer updatescore(@Param("peExaminationAppointmentScore") Double peExaminationAppointmentScore,@Param("peExaminationAppointmentId") Integer peExaminationAppointmentId);

    Integer updatenormalscore(@Param("peExaminationNormalscore") Double peExaminationNormalscore,@Param("peExaminationAppointmentId") Integer peExaminationAppointmentId);

    Integer updatemidscore(@Param("peExaminationMidscore") Double peExaminationMidscore,@Param("peExaminationAppointmentId") Integer peExaminationAppointmentId);

    Integer updatetotalscore(@Param("peExaminationTotalscore") Double peExaminationTotalscore,@Param("peExaminationAppointmentId") Integer peExaminationAppointmentId);

    List<PeExaminationAppointment> getData(@Param("systemYearId") Integer systemYearId, @Param("peExaminationAppointmentScore") Double peExaminationAppointmentScore, @Param("peExaminationId") Integer peExaminationId, @Param("userStudentInfoNum") String userStudentInfoNum,@Param("systenSelectcourseCode")String systenSelectcourseCode);

}